SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweCertificadosConceptosLiquidacion
AS
SELECT     idCertificado AS ID, Agente, TipoCertificado, ValidezDesde, ValidezHasta, Observaciones, FPP, Habilitado
FROM         dbo.tb_CertificadosConceptosLiquidacion
GO
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [PersonalDocente]
GRANT INSERT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [PersonalDocente]
GRANT DELETE ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [SoloVer]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [Subsidios]
GRANT INSERT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [Subsidios]
GRANT DELETE ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [Subsidios]
GRANT UPDATE ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [Subsidios]
GRANT SELECT ON  [dbo].[vweCertificadosConceptosLiquidacion] TO [SubsidiosConsulta]
GO
